USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_EmployeeDelete'))
	EXEC('CREATE PROC dbo.training_api_EmployeeDelete AS')
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[training_api_EmployeeDelete]
	@EmployeeID	int
AS
	DELETE FROM Employee
	WHERE EmployeeID = @EmployeeID